<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="en">
<head>
    <title>MydbQA - Analyze report</title>
    <link href="style/main.css" rel="stylesheet" type="text/css" />
    <link href="style/highlight/styles/default.css" rel="stylesheet" type="text/css" />
    <TMPL_UNLESS nohighlight>
        <script type="text/javascript" src="style/highlight/highlight.js"></script>
        <script type="text/javascript">initHighlightingOnLoad();</script>
    </TMPL_UNLESS>
</head>
<body>
    <br />
    <div id="indexes_data">
        <h1>Indexes data</h1><br />
        <TMPL_LOOP indexes>
            <div class="box mt10">
                <p>Table: <b><TMPL_VAR indexes_t></b></p>
                <table>
                    <tr class="header">
                        <td>Non_unique</td>
                        <td>Key_name</td>
                        <td>Seq_in_index</td>
                        <td>Column_name</td>
                        <td>Collation</td>
                        <td>Cardinality</td>
                        <td>Sub_part</td>
                        <td>Packed</td>
                        <td>Null</td>
                        <td>Index_type</td>
                        <td>Comment</td>
                    </tr>
                    <TMPL_LOOP indexes_t_read>
                    <tr>
                        <td><TMPL_VAR Non_unique></td>
                        <td><TMPL_VAR Key_name></td>
                        <td><TMPL_VAR Seq_in_index></td>
                        <td><TMPL_VAR Column_name></td>
                        <td><TMPL_VAR Collation></td>
                        <td><TMPL_VAR Cardinality></td>
                        <td><TMPL_VAR Sub_part></td>
                        <td><TMPL_VAR Packed></td>
                        <td><TMPL_VAR Null></td>
                        <td><TMPL_VAR Index_type></td>
                        <td><TMPL_VAR Comment></td>
                    </tr>
                    </TMPL_LOOP>
                </table>
            </div>
        </TMPL_LOOP>
    </div>
    <div id="possible_indexes">
        <br /><h1>Possible indexes</h1><br />
        <TMPL_LOOP seq>
            <div class="box mt10">
                <pre><code class="sql"><TMPL_VAR indexes_seq_sql></code></pre>
                <div class="line">&nbsp;</div>
                <p>Explain:</p>
                <table>
                    <tr class="header">
                        <td>Id</td>
                        <td>Select type</td>
                        <td>Table</td>
                        <td>Type</td>
                        <td>Possible keys</td>
                        <td>Key</td>
                        <td>Key length</td>
                        <td>Ref</td>
                        <td>Rows</td>
                        <td>Extra</td>
                    </tr>
                    <TMPL_LOOP indexes_seq_explain>
                    <tr>
                        <td><TMPL_VAR id></td>
                        <td><TMPL_VAR select_type></td>
                        <td><TMPL_VAR table></td>
                        <td><TMPL_VAR type></td>
                        <td><TMPL_VAR possible_keys></td>
                        <td><TMPL_VAR key></td>
                        <td><TMPL_VAR key_len></td>
                        <td><TMPL_VAR ref></td>
                        <td><TMPL_VAR rows></td>
                        <td><TMPL_VAR Extra></td>
                    </tr>
                    </TMPL_LOOP>
                </table>
                <p>Total rows: <b><TMPL_VAR indexes_seq_totalrows></b></p>
                <p>Execution time: <b><TMPL_VAR indexes_seq_bench></b></p>
            </div>
        </TMPL_LOOP>
    </div>
    
    <br /><br/>
</body>
</html>